2013-11-26 - 9203.400 - Spec - Create a source for Sell thru data in BW #InventoryManagement

SPECIFICATIONS

9203.400 - Create a source for Sell thru data in BW

Requirement Summary

Create a Sell Thru Source in BPD (BW 7.3 Development).

Admin Info

Purpose	Create a source for Sell thru data in BW
Requested By	Bill Adams
Spec Created By	Chandramouli K
Spec Created Date	11/26/2013
Spec QA by	Uday Kumar P
Objects	Sell Thru DSO(ZSD_OSEL), Sell Thru infocube(ZSD_SELT) and Sell Thru MultiProvider (ZMP_OOSEL)
Document Status	Complete

References

Prior Tickets

None

Documents

Attached with related Release Notes.

Functional Requirement

1. Need to create a new Datastore Object(DSO) with required Characteristics, Key Figures and Navigational Attributes to meet the NEC requirements.
2. Need to create a new infocube with same Objects as in Sell thru DSO and map it to the above DSO Object.
3. Need to create a new Multiprovider to combine Sell Thru information from infocube with Open Orders, Order Condition and Contract infocubes.
4. Need to create Transport requests in BPD(BW 7.3 Development) and collect all the objects like DSO, infocube, Multiprovider & their dataflows.

New Requirement on 04/23/2014 - Ashwin by IM
1. Need to Create and Add ZFISCWEK2 to Contract, Open Order, Condition Cube's and changes to Sel thru MultiProvider.

Solution Summary

1. Create a new Sell thru Datastore Object with required Characteristics, Key Figures and Navigational Attributes.
2. Need to maintain the Key part and Data part in the DSO based on key fields.
3. Define generic datasource based on view defined in NED for extracting data into BPD.
4. Need to replicate the datasource from source systems NED100 & NED300.
5. Create transformations for DSO with the fields of the Datasource.
6. Create the Full load infopackage as the Sell thru source is always full load due to the file interface.
7. Create the Data Transfer Process between DSO and the datasource.
8. Create a new infocube with the same fields as in DSO Object.
9. Create the Data Transfer Process between DSO and infocube.
10. Create a new Multiprovider to combine Sell Thru infocube with Open Orders, Order Condition and Contract order infocubes.
11. Assign the objects in Multiprovider from respective infoproviders as per NEC requirement.
12. Create a Sell Thru Dataflow similarly in NED300 source system as it exists in NED100 source system.
13. Collect the DSO object, infocube, Multiprovider & their dataflows in separate transport requests.
14. Unit Test the sources in BPD and then transport them to BPQ(BW 7.3 Quality) for further testing.
New Requirement on 04/23/2014 - Ashwin by IM
1. Create and Add ZFISCWEK2 to Contract, Open Order, Condition Cube's and changes to Sel thru MultiProvider.

Test Plan

SNo.	Test Scenario	Expected Results
1	Check if the data is correctly loaded in DSO Obejct.	Data should be correctly loaded.
2	Check if the data is correctly loaded into infocube.	Data should be correctly loaded.
3	Check the above sources against NEC Standard Infoprovider development checklist.	Infoproviders should be successfully validated as per checklist.
4	Check if the value of ZFISCWEK2 correct in all the sources of Sel thru MultiProvider.	Value should be consistent.

Solution Details

1. Create a new Sell thru Datastore Object ZSD_OSEL with required Characteristics, Time Characteristics, Key Figures and Navigational Attributes.
2. Need to maintain the key part and data part of the DSO ZSD_OSEL as per NEC requirement.
3. Define a generic datasource ZSD_SELL_THRU_DATA based on view defined in NED for extracting data into BPD.
4. Replicate the datasource ZSD_SELL_THRU_DATA from source systems NED100 & NED300 into BPD100.
5. Create transformation for DSO ZSD_OSEL with the fields of the Datasource ZSD_SELL_THRU_DATA.
6. Create the Full load infopackage as the Sell thru source is always full load due to the file interface.
7. Create the Data Transfer Process between ZSD_OSEL DSO and the datasource ZSD_SELL_THRU_DATA.
8. Create a new infocube ZSD_SELT with the same fields as in DSO Object.
9. Create the Data Transfer Process between DSO ZSD_OSEL and infocube ZSD_SELT.
10. Create a new Multiprovider ZMP_OOSEL to combine Sell Thru infocube with Open Orders ZSDC_OPN, Order Condition ZSD_C15 and
Contract order ZSD_CONTR infocubes.
11. Assign theobjects in Multiprovider ZMP_OOSEL from respective infoproviders as per NEC requirement.
12. Create the Sell Thru Dataflow similarly in NED300 source system as that of NED100 system for unit testing.
13. Collect the DSO ZSD_OSEL, infocube ZSD_SELT, Multiprovider ZMP_OOSEL and their dataflows in separate transport requests.
14. Check whether all the objects are collected into the transport requets & then transport them to BPQ(BW 7.3 Quality) for further testing.
New Requirement on 04/23/2014 - Ashwin by IM
1. Create and Add ZFISCWEK2 to Contract, Open Order, Condition Cube's and do assignment of ZFISCWEK2 from all the sources of sel thru MultiProvider.